ON "CLIENTS"&20Client.CLIENTS AS "Client" ON "TRANS"@22Trans_Date.TRANS AS " Date",Transaction ref.TRANS AS "Ref",Trans_Type.TRANS,USD Value.TRANS AS " $ Value",Comm_Value.TRANS AS " Commission",(USD Value.TRANS + Comm_Value.TRANS) AS " Balance"
REPORT SUM USD Value.TRANS,Comm_Value.TRANS," Balance" GROUP Customer_Ref.TRANS SUM USD Value.TRANS,Comm_Value.TRANS," Balance"